{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Меню ГПД!!"],"read":"whole","date_system":"1900"}

{"sheet":"Меню ГПД!!","index":0,"n_rows":109,"n_cols":15,"rows_kept":109,"merged":[[0,0,0,8],[2,0,2,2],[57,0,57,2]]}
["Примерное двухнедельное цикличное меню для группы продленного дня"]
[]
["1 неделя"]
["№ Сб.рец","Наименование продуктов","Выход,г","Белки","Жиры","Угл-ды","Энер.ценность (ККАЛ)","В1","С","А","Е","Са","Р","Mg","Fe"]
[null,"Понедельник"]
[null,"Меню дополнительного питания"]
["№ 111/2004","Борщ Сибирский со сметаной, с мясом","250/10/11",7.88,6.99,13.06,119,0.03,9.6,1.3,0.8,50.3,170.9,23.5,1]
["табл 24/1996","Каша манная молочная с маслом сливочным","200/10",9.9,9.8,41.8,294,0.1,null,null,1.65,28.5,105,43.5,1.2]
["№ 639/2004","Компот из урюка",200,1.2,null,32.6,196,0.02,0.8,null,1.1,32.6,29.2,21,1.2]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",721,{"$f":"SUM(D7:D10)","v":21.88},{"$f":"SUM(E7:E10)","v":17.59},{"v":104.46000000000001,"d":"104.46"},{"v":699,"d":"699.00"},0.19,{"v":10.4,"d":"10.40"},{"v":1.3,"d":"1.30"},3.95,{"v":120.80000000000001,"d":"120.80"},{"v":347.09999999999997,"d":"347.10"},{"v":100,"d":"100.00"},4.44]
[]
[null,"ВТОРНИК"]
[null,"Меню дополнительного питания"]
["113/2017","Суп - лапша с картофелем с мясом птицы","250/10",4.675,6.9,11.62,136.42,0.053,0.5,14.5,2.575,32.45,52.8,12.67,0.83]
["№ 340/2004","Омлет натуральный",200,{"v":20,"d":"20.00"},{"v":16,"d":"16.00"},{"v":66.53333333333333,"d":"66.53"},{"v":397.3333333333333,"d":"397.33"},{"v":0.013333333333333334,"d":"0.01"},{"v":0.013333333333333334,"d":"0.01"},{"v":48,"d":"48.00"},{"v":0.4,"d":"0.40"},{"v":37.333333333333336,"d":"37.33"},{"v":81.06666666666666,"d":"81.07"},{"v":6.133333333333333,"d":"6.13"},{"v":0.9066666666666666,"d":"0.91"}]
["243/2017","Сосиски отварная",100,12,7.6,16,180,0.3,null,null,0.5,33.4,182.8,19.78,2.4]
["№ 639/2004","Напиток из сухофруктов",200,0.85,0.03,34.8,143,0.06,null,null,0.1,16.5,25.8,8.4,0.7]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",800,{"$f":"D15+D16+D17+D18+D19","v":{"v":40.425,"d":"40.43"}},{"$f":"E15+E16+E17+E18+E19","v":{"v":31.330000000000002,"d":"31.33"}},{"v":145.95333333333332,"d":"145.95"},{"v":946.7533333333333,"d":"946.75"},{"v":0.46633333333333327,"d":"0.47"},{"v":0.5133333333333333,"d":"0.51"},{"v":62.5,"d":"62.50"},{"v":3.975,"d":"3.98"},{"v":129.08333333333334,"d":"129.08"},{"v":384.4666666666667,"d":"384.47"},{"v":58.983333333333334,"d":"58.98"},{"v":5.876666666666667,"d":"5.88"}]
[]
[null,"СРЕДА"]
[null,"Меню дополнительного питания"]
["№ 243/2004","Суп гороховый с гренками, с мясными фрикадельками","250/10/22",5.9,6.5,20.9,232,0.12,0.8,null,0.8,66,262,38,1.8]
["174/ 2017","Каша молочная кукурузная с маслом сливочным","200/3",7.6,8.925,50.74,314.2,0.09,0.96,42.8,0.37,137.75,152.71,31.61,1.67]
["№ 478/2004","Булочка с сахаром",50,3.88,2.36,23.55,131,0.07,null,13,0.69,11,37,14.5,0.69]
["Акт 2016","Компот из кураги",200,0.56,0.07,24.87,106.6,0.1,0.5,null,0.45,26.32,20.63,12.84,0.47]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",775,{"$f":"SUM(D24:D28)","v":{"v":20.839999999999996,"d":"20.84"}},{"$f":"SUM(E24:E28)","v":{"v":18.655,"d":"18.66"}},137.06,{"v":873.8000000000001,"d":"873.80"},0.42,2.26,{"v":55.8,"d":"55.80"},2.71,250.47,514.34,108.95,5.67]
[]
[null,"ЧЕТВЕРГ"]
[null,"Меню дополнительного питания"]
["№ 132/2004","Рассольник ленинградский со сметаной","250/10",3.9,2.1,38.9,151.3,0.06,5.34,13.4,0.2,11.5,49.8,17.8,0.68]
["ТТК 656 от 28.04.2020","Блины со сгущенным молоком","135/20",12.8,13.9,53.8,369,0.09,null,null,1.7,7,63,25,1.4]
["№685/2004","Чай с сахаром","200/15",0.2,null,13.7,53,{"$nulls":4},0.4,null,null,0.4]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",670,{"$f":"SUM(D33:D36)","v":{"v":19.799999999999997,"d":"19.80"}},{"$f":"SUM(E33:E36)","v":{"v":16.8,"d":"16.80"}},{"v":123.39999999999999,"d":"123.40"},{"v":663.3,"d":"663.30"},0.19,5.34,{"v":13.4,"d":"13.40"},{"v":2.3,"d":"2.30"},{"v":28.299999999999997,"d":"28.30"},{"v":154.8,"d":"154.80"},{"v":54.8,"d":"54.80"},3.52]
[]
[null,"ПЯТНИЦА"]
[null,"Меню дополнительного питания"]
["№99 /2017","Суп из овощей со сметаной","250/10",1.847,6.49,9.51,111.45,0.073,10.415,10,2.355,43.65,55.38,21.65,0.795]
["Т4/302/2004","Каша пшеничная молочная",200,8.28,12.49,39.96,{"v":250,"d":"250.00"},0.11,0.15,52.8,0.2,94.1,121,32.1,0.86]
["Акт 2019г","Курица отварная",100,21.98,18.01,0.36,{"v":248,"d":"248.00"},0.06,4.7,51.2,0.27,55.2,122.5,5.4,1.48]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,{"v":90,"d":"90.00"},0.04,null,null,0.4,9.4,42,12,1.04]
["Акт 2016 ","Кисель детский витаминизированный",200,null,null,19.7,{"v":74,"d":"74.00"},{"$nulls":4},0.2,null,null,0.03]
[null,"Итого:",800,{"$f":"SUM(D41:D45)","v":{"v":35.007,"d":"35.01"}},{"$f":"SUM(E41:E45)","v":37.79},86.53,773.45,{"v":0.283,"d":"0.28"},{"v":15.265,"d":"15.27"},{"v":114,"d":"114.00"},{"v":3.225,"d":"3.23"},{"v":202.54999999999998,"d":"202.55"},340.88,71.15,{"v":4.205,"d":"4.21"}]
[]
[null,"СУББОТА"]
[null,"Меню дополнительного питания"]
["98/2017","Суп крестьянский с крупой со сметаной","250/10",1.743,6.417,6.45,92.45,0.046,9.915,10,2.33,44.675,39.675,15.08,0.595]
["№3 /2017","Бутерброд с сыром",50,6.27,7.86,14.83,{"v":155,"d":"155.00"},0.04,0.15,51.5,0.45,157.2,111,12.45,0.45]
["табл 4/302/2004","Каша геркулесовая молочная с маслом сливочным","200/5",11.9,6.1,35.6,{"v":230,"d":"230.00"},0.1,0.17,54.6,0.5,69.8,130,37.1,0.87]
["№ 639/2004","Напиток из сухофруктов",200,0.85,0.03,34.8,{"v":143,"d":"143.00"},0.06,null,null,0.1,16.5,25.8,8.4,0.7]
[null,"Итого:",715,{"$f":"SUM(D50:D53)","v":{"v":20.763,"d":"20.76"}},{"$f":"SUM(E50:E53)","v":{"v":20.407000000000004,"d":"20.41"}},91.68,620.45,{"v":0.246,"d":"0.25"},{"v":10.235,"d":"10.24"},{"v":116.1,"d":"116.10"},{"v":3.3800000000000003,"d":"3.38"},{"v":288.175,"d":"288.18"},{"v":306.475,"d":"306.48"},73.03,{"v":2.615,"d":"2.62"}]
[]
[null,"Всего за 6 дней:",{"$f":"C11+C20+C29+C37+C46+C54","v":4481},{"$f":"D11+D20+D29+D37+D46+D54","v":{"v":158.71499999999997,"d":"158.72"}},{"$f":"E11+E20+E29+E37+E46+E54","v":{"v":142.572,"d":"142.57"}},{"v":689.0833333333333,"d":"689.08"},{"v":4576.753333333333,"d":"4,576.75"},{"v":1.795333333333333,"d":"1.80"},{"v":44.013333333333335,"d":"44.01"},{"v":363.1,"d":"363.10"},{"v":19.540000000000003,"d":"19.54"},{"v":1019.3783333333333,"d":"1,019.38"},{"v":2048.0616666666665,"d":"2,048.06"},{"v":466.9133333333333,"d":"466.91"},{"v":26.326666666666668,"d":"26.33"}]
[]
["2 неделя"]
[null,"Понедельник"]
[null,"Меню дополнительного питания"]
["№82/2017","Борщ из свежей капусты с мясными фрикадельками,со сметаной","250/11/10",4.257,7.709,11.37,141.77,0.06,10.77,12.2,2.5,60.89,83.54,30.57,1.42]
["174/ 2017","Каша молочная кукурузная с маслом сливочным","200/3",7.6,8.925,50.74,{"v":314.2,"d":"314.20"},0.09,0.96,42.8,0.37,137.75,152.71,31.61,1.67]
["Акт 2016","Компот из урюка",200,0.2,null,13.7,{"v":53,"d":"53.00"},{"$nulls":4},0.4,null,null,0.4]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,{"v":90,"d":"90.00"},0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",714,{"$f":"SUM(D61:D64)","v":{"v":14.956999999999999,"d":"14.96"}},{"v":17.434,"d":"17.43"},92.81,598.97,0.19,11.73,{"v":55,"d":"55.00"},3.27,208.44,278.25,74.18,{"v":4.529999999999999,"d":"4.53"}]
[]
[null,"ВТОРНИК"]
[null,"Меню дополнительного питания"]
["№97/2017","Суп картофельный с мясом птицы","250/10",4.45,4.187,16.87,134.66,0.132,12,2,1.305,34.35,92.03,33.4,1.38]
["№ 366/2004","Запеканка из творога со сгущенным молоком","150/20",{"v":18.8,"d":"18.80"},{"v":18.666666666666668,"d":"18.67"},{"v":78.8,"d":"78.80"},{"v":549.3333333333334,"d":"549.33"},0.08,{"v":0.26666666666666666,"d":"0.27"},{"v":101.06666666666666,"d":"101.07"},{"v":0,"d":"0.00"},{"v":188,"d":"188.00"},{"v":243.6,"d":"243.60"},{"v":29.466666666666665,"d":"29.47"},{"v":0.7066666666666667,"d":"0.71"}]
["№ 686/2004","Чай с сахаром, лимоном","200/15/7",0.2,0.1,13.9,55,null,1.12,null,null,2.9,1.3,0.7,0.08]
["табл 6 стр 134 Дели +,2012","Батон высший сорт",30,2.25,0.87,15.42,79,0.02,null,null,0.2,4.7,21.1,6.3,0.52]
[null,"Итого:",682,{"$f":"SUM(D69:D72)","v":{"v":25.7,"d":"25.70"}},{"$f":"SUM(E69:E72)","v":{"v":23.82366666666667,"d":"23.82"}},{"v":124.99000000000001,"d":"124.99"},{"v":817.9933333333333,"d":"817.99"},{"v":0.232,"d":"0.23"},{"v":13.386666666666667,"d":"13.39"},{"v":103.06666666666666,"d":"103.07"},{"v":1.505,"d":"1.51"},229.95,{"v":358.03000000000003,"d":"358.03"},{"v":69.86666666666666,"d":"69.87"},{"v":2.6866666666666665,"d":"2.69"}]
[]
[null,"СРЕДА"]
[null,"Меню дополнительного питания"]
["№ 140/2004","Суп из овощей с фрикадельками мясными ","250/11",7.6,36.5,198,0.02,8,14.7,0.3,23.9,39,13,0.54]
["174/2017","Каша  кукурузная  молочная с маслом сливочным","200/5",5.69,5.79,{"v":38.04,"d":"38.0"},227.4,0.07,{"v":0.72,"d":"0.7"},27.1,0.55,{"v":103.01,"d":"103.0"},{"v":114.16,"d":"114.2"},{"v":23.71,"d":"23.7"},1.25]
["Акт 2016 ","Кисель детский витаминизированный",200,null,null,19.7,74,{"$nulls":4},0.2,null,null,0.03]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","30/30",4.3,1.3,25.4,136,0.06,null,null,0.6,14.1,63,18,1.56]
[null,"Итого:",726,{"$f":"SUM(D77:D80)","v":17.59},{"$f":"SUM(E77:E80)","v":{"v":43.589999999999996,"d":"43.59"}},281.14,437.42,8.13,15.42,{"v":27.400000000000002,"d":"27.40"},25.05,{"v":156.30999999999997,"d":"156.31"},190.16,42.25,2.84]
[]
[null,"ЧЕТВЕРГ"]
[null,"Меню дополнительного питания"]
["№ 140/2004","Суп картофельный с макаронными изделиями,фрикадельками из птицы ","200/22",{"v":3.51,"d":"3.5"},32.5,{"v":173,"d":"173.0"},0.06,{"v":0.0528,"d":"5.28%"},8.5,0.3,11,44.6,16.7,0.7]
["табл 4/302/2004","Каша рисовая молочная с маслом сливочным","200/5",9.8,8.8,36.8,209.9,0.03,0.52,23.7,0.2,107,94.2,17.4,0.2]
["№ 686/2004","Чай с сахаром,с урюком ","200/15/7",0.2,0.1,32.6,263,null,1.12,null,null,2.9,1.3,0.7,0.08]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",580,{"$f":"SUM(D85:D88)","v":{"v":16.41,"d":"16.4"}},{"$f":"SUM(E85:E88)","v":{"v":42.199999999999996,"d":"42.2"}},259.4,{"v":562.96,"d":"563.0"},{"v":0.12279999999999999,"d":"0.1"},{"v":10.14,"d":"10.1"},{"v":24,"d":"24.0"},11.6,163.9,154.2,{"v":30.799999999999997,"d":"30.8"},{"v":1.32,"d":"1.3"}]
[]
[null,"ПЯТНИЦА"]
[null,"Меню дополнительного питания"]
["№ 124/2004","Щи из свежей капусты с картофелем, сметаной, мясом","250/10/11",4.16,9.2,96,0.02,8,14.7,0.3,23.9,39,13,0.54,1.9]
["табл 4/302/2004","Каша геркулесовая молочная с маслом сливочным","200/5",11.9,6.1,35.6,230,0.1,0.17,54.6,0.5,69.8,130,37.1,0.87]
["№ 639/2004","Напиток из сухофруктов",200,0.85,0.03,34.8,143,0.06,null,null,0.1,16.5,25.8,8.4,0.7]
["табл 6 стр 144 Дели +,2012","Хлеб сельский/белый","20/20",2.9,0.8,17,90,0.04,null,null,0.4,9.4,42,12,1.04]
[null,"Итого:",716,{"$f":"SUM(D93:D96)","v":{"v":19.810000000000002,"d":"19.81"}},{"$f":"SUM(E93:E96)","v":16.13},{"v":183.39999999999998,"d":"183.40"},463.02,{"v":8.2,"d":"8.20"},14.87,{"v":54.9,"d":"54.90"},{"v":24.9,"d":"24.90"},{"v":134.7,"d":"134.70"},{"v":210.8,"d":"210.80"},58.04,4.51]
[]
[null,"СУББОТА"]
[null,"Меню дополнительного питания"]
["№ 102/2017","Суп картофельный с фасолью",250,5.49,5.27,16.54,148.25,0.23,5.83,null,{"v":2.425,"d":"2.43"},42.68,{"v":88.1,"d":"88.10"},35.58,2.05]
["174/ 2017","Каша молочная кукурузная с маслом сливочным","200/3",7.6,8.925,50.74,314.2,0.09,0.96,42.8,0.37,137.75,152.71,31.61,1.67]
["№685/2004","Чай с сахаром","200/15",0.2,null,13.7,53,{"$nulls":4},0.4,null,null,0.4]
["табл 6 стр 134 Дели +,2012","Батон высший сорт",30,2.25,0.87,15.42,79,0.02,null,null,0.2,4.7,21.1,6.3,0.52]
[null,"Итого:",698,{"$f":"SUM(D101:D104)","v":15.54},{"$f":"SUM(E101:E104)","v":{"v":15.065,"d":"15.07"}},{"v":96.4,"d":"96.40"},594.45,0.34,6.79,{"v":42.8,"d":"42.80"},{"v":2.995,"d":"3.00"},185.53,261.91,73.49,{"v":4.640000000000001,"d":"4.64"}]
[]
[null,"Всего:",{"$f":"C65+C73+C81+C89+C97+C105","v":4116},{"v":110.007,"d":"110.01"},{"v":158.24266666666665,"d":"158.24"},{"v":1038.1399999999999,"d":"1038.14"},{"v":3474.8133333333335,"d":"3474.81"},{"v":17.2148,"d":"17.21"},{"v":72.33666666666667,"d":"72.34"},{"v":307.1666666666667,"d":"307.17"},{"v":69.32000000000001,"d":"69.32"},1078.83,1453.35,{"v":348.6266666666667,"d":"348.63"},{"v":20.526666666666664,"d":"20.53"}]
[null,"Всего за 12 дней:",{"$f":"C56+C107","v":8597},{"v":268.722,"d":"268.72"},{"v":300.81466666666665,"d":"300.81"},{"v":1727.2233333333331,"d":"1,727.22"},{"v":8051.566666666667,"d":"8,051.57"},{"v":19.010133333333332,"d":"19.01"},{"v":116.35000000000001,"d":"116.35"},{"v":670.2666666666667,"d":"670.27"},{"v":88.86000000000001,"d":"88.86"},{"v":2098.208333333333,"d":"2,098.21"},{"v":3501.4116666666664,"d":"3,501.41"},815.54,{"v":46.85333333333333,"d":"46.85"}]
[null,"В среднем на 1 учащегося в день",{"$f":"C108/12","v":{"v":716.4166666666666,"d":"716"}},{"$f":"D108/12","v":{"v":22.3935,"d":"22.39"}},{"$f":"E108/12","v":{"v":25.067888888888888,"d":"25.07"}},{"v":143.93527777777777,"d":"143.94"},{"v":670.9638888888888,"d":"670.96"},{"v":1.5841777777777777,"d":"1.58"},{"v":9.695833333333335,"d":"9.70"},{"v":55.855555555555554,"d":"55.86"},{"v":7.405000000000001,"d":"7.41"},{"v":174.85069444444443,"d":"174.85"},{"v":291.78430555555553,"d":"291.78"},{"v":67.96166666666666,"d":"67.96"},{"v":3.904444444444444,"d":"3.90"}]